package com.ycz.sas.jgen.manager;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.ycz.sas.jgen.dao.JdbcDAO;


public class UserManager {
	
	private JdbcDAO jdbcDAO;
	
	public void setJdbcDAO(JdbcDAO jdbcDAO){
		this.jdbcDAO = jdbcDAO;
	}
	
	public ResultSet executeQuery(String sql) throws SQLException, ClassNotFoundException{
		return jdbcDAO.executeQuery(sql);
	}
	
	public ResultSet findUserByName(String userName) throws SQLException, ClassNotFoundException{
		String sql = "select * from t_pm_user where fname_l2 = '"+userName+"' ";
		return jdbcDAO.executeQuery(sql);
	}
	
}
